package com.mall.dubbo.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.mall.model.domain.UmsMenu;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author xyiaao
 * @description 针对表【ums_menu(后台菜单表)】的数据库操作Mapper
 * @createDate 2022-03-29 19:46:09
 * @Entity com.mall.model.domain.UmsMenu
 */
public interface UmsMenuMapper extends BaseMapper<UmsMenu> {

    @Select("select t1.* from ums_menu t1 join ums_role_menu_relation t2 on t2.role_id = #{roleId} and t1.id = t2.menu_id")
    List<UmsMenu> listUmsMenuByRoleId(Long roleId);

}




